Wednesday, April 5, 2023

How to Create New Data adaptor in Jasper report and connect oracle database

How to connect oracle database in jasper report

Follow the below steps 

  • Open Jasper report and Find the Data Adapter
  • Right click the data adapter and click Create Data adapter
  • Enter the connection name like “STUDENT”
  • Select JDBC Driver like “oracle.jdbc.driver.OracleDriver”
  • Enter JDBC Url your database name like “ XE “ and enter user name and password
  • Select Driver classpath in bottom of window
  • Add your ojdbc7.jar file in your respective folder.. Or you can download the below link
  • Download ojdbc :  https://drive.google.com/file/d/1ozFc5M6o6ExXBS4qUfgihIZR4XoEtlza/view?usp=share_link
  • Click the Test button you have a success message 
  • Now click the Finish button and see the respective connection

Now you can enjoy to create the reports!!!

Follow the youtube channel : https://www.youtube.com/@oracleapextamil


To learn oracle apex development, how to create project and publish the application in online

Beginner's Guide to Oracle APEX

Oracle Apex | Oracle Apex Tutorials 

Oracle APEX for Beginners  

Low Code App Dev with Oracle APEX: Building a Simple Movie App

Visit blog and get more solutions : https://parthiban037.wordpress.com

No comments:

Post a Comment

Oracle Apex Universal Theme complete tutorial

https://apex.oracle.com/pls/apex/r/apex_pm/ut/getting-started --login backaground css ====================== .t-PageBody--login { background...